|
오라클 실습 |
[1] |
|
등록일:2009-05-28 00:19:33 (0%) 작성자: 제목:5. 당일분, 일주일분, 한달분의 판매량을 구하라. |
|
Select saledept,
Sum(decode(saledate, to_char(sysdate,’yyyymmdd’), chulqty,0)) as ‘당일합계’
,Sum(decode(sign(8-(sysdate-to_date(saledate,’yyyymmdd’))),1,chulqty)) as ‘일주일분합계’
,substr(max(saledate||chulqty),9,20) as ‘최근최고분’
,sum(saleamt) as ‘월간합계’
from 판매테이블
where saledate like ‘9610%’
group by saledept; |
[본문링크] 5. 당일분, 일주일분, 한달분의 판매량을 구하라.
|
[1]
|
|
|
|
|
코멘트(이글의 트랙백 주소:/cafe/tb_receive.php?no=31511 |
|
|
|
|
|
|
|
|
|
Copyright byCopyright ⓒ2005, SSISO Community All Rights Reserved.
|
|
|